﻿CREATE TABLE [dbo].[sys_CustomerCardType](
	[CardTypeID] [int] NOT NULL,
	[CardTypeName] [nvarchar](50) NOT NULL,
	[DisCount] [decimal](18, 2) NOT NULL,
	[IsDeleted] [int] NOT NULL,
 CONSTRAINT [PK_sys_CustomerCardType] PRIMARY KEY CLUSTERED 
(
	[CardTypeID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

INSERT dbo.sys_CustomerCardType(CardTypeID,CardTypeName, DisCount, IsDeleted )
VALUES  (1, '金卡',0.5,0);

INSERT dbo.sys_CustomerCardType(CardTypeID, CardTypeName, DisCount, IsDeleted )
VALUES  ( 2,'银卡',0.5,0);

INSERT dbo.sys_CustomerCardType(CardTypeID, CardTypeName, DisCount, IsDeleted )
VALUES  (3, '钻石卡',0.5,0);
          
